/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:3306
 Source Schema         : vue-ego

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 23/01/2023 22:30:13
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int DEFAULT NULL,
  `name` text,
  `cid` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1, '家用电器', 1001);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1, '手机/运营商/数码', 1002);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1, '电脑/办公', 1003);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1, '家具/家居', 1004);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1001, '电视', 10001);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1001, '空调', 10002);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1001, '洗衣机', 10003);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1001, '冰箱', 10004);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1002, '手机通讯', 10001);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1002, '运营商', 10002);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1002, '摄影', 10003);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1002, '摄像', 10004);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1003, '电脑整机', 10001);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1003, '电脑配件', 10002);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1003, '外设产品', 10003);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1003, '游戏设备', 10004);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1004, '厨具', 10001);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1004, '家纺', 10002);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1004, '灯具', 10003);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1004, '家具', 10004);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (10001, '超薄点视', 100001);
INSERT INTO `category` (`id`, `name`, `cid`) VALUES (10001, '全面屏点视', 100002);
COMMIT;

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `address` text NOT NULL,
  `phone` text NOT NULL,
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of order
-- ----------------------------
BEGIN;
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (1, 'xiaotian', '资阳市', '123456789', '准时送到', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (10, '张三', '资阳市', '123456789', '别损坏了', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (11, '李四', '资阳市', '123456789', '快速送到', 0);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (12, '小明', '资阳市', '123456789', '快速送到', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (13, '刘小强', '资阳市', '123456789', '快速送到', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (14, '张美美', '资阳市', '123456789', '快速送到', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (15, '周倩', '资阳市', '123456789', '别损坏了', 0);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (16, '小美', '资阳市', '123456789', '别损坏了', 0);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (17, '李华', '资阳市', '123456789', '别损坏了', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (18, '小刘', '资阳市', '123456789', '别损坏了', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (19, '张明', '资阳市', '123456789', '别损坏了', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (20, '小花', '资阳市', '123456789', '快速送到', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (21, '小华', '资阳市', '123456789', '快速送到', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (22, '小张', '资阳市', '123456789', '快速送到', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (23, '李五', '资阳市', '123456789', '别损坏了', 0);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (24, '李七', '资阳市', '23456789', '快速送到', 0);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (25, '刘五', '资阳市', '123456789', '快速送到', 0);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (26, '小琴', '资阳市', '23456789', '别损坏了', 1);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (27, '李六', '资阳市', '23456789', '快速送到', 0);
INSERT INTO `order` (`id`, `username`, `address`, `phone`, `remarks`, `status`) VALUES (28, '张华', '资阳市', '23456789', '别损坏了', 1);
COMMIT;

-- ----------------------------
-- Table structure for params
-- ----------------------------
DROP TABLE IF EXISTS `params`;
CREATE TABLE `params` (
  `id` int NOT NULL AUTO_INCREMENT,
  `itemCatId` text NOT NULL,
  `paramData` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10037 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of params
-- ----------------------------
BEGIN;
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10005, '1001', '[{\"value\":\"品牌\",\"children\":[{\"childValue\":\"戴尔\",\"value\":\"\"},{\"childValue\":\"宏碁\",\"value\":\"\"},{\"childValue\":\"mac\",\"value\":\"\"},{\"childValue\":\"小米\",\"value\":\"\"}]},{\"value\":\"内存\",\"children\":[{\"value\":\"\",\"childValue\":\"256\"},{\"childValue\":\"固态\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10006, '1002', '[{\"title\":\"安卓\",\"value\":\"\",\"children\":[{\"title\":\"华为\",\"value\":\"\"},{\"title\":\"小米\",\"value\":\"\"}]},{\"title\":\"苹果\",\"value\":\"\",\"children\":[{\"title\":\"iphone13\",\"value\":\"\"},{\"title\":\"iphone12\",\"value\":\"\"},{\"title\":\"iphone11\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10007, '1003', '[{\"title\":\"windows\",\"value\":\"\",\"children\":[{\"title\":\"联想\",\"value\":\"\"},{\"title\":\"华为\",\"value\":\"\"},{\"title\":\"拯救者\",\"value\":\"\"}]},{\"title\":\"macos\",\"value\":\"\",\"children\":[{\"title\":\"macbook\",\"value\":\"\"},{\"title\":\"macbook pro\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10008, '1004', '[{\"value\":\"电脑\",\"children\":[{\"childValue\":\"网线\",\"value\":\"\"},{\"childValue\":\"接口\",\"value\":\"\"}]},{\"value\":\"鼠标\",\"children\":[{\"childValue\":\"有限\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10009, '1005', '[{\"value\":\"品牌\",\"children\":[{\"childValue\":\"戴尔\",\"value\":\"\"},{\"childValue\":\"宏碁\",\"value\":\"\"},{\"childValue\":\"mac\",\"value\":\"\"},{\"childValue\":\"小米\",\"value\":\"\"}]},{\"value\":\"内存\",\"children\":[{\"value\":\"\",\"childValue\":\"256\"},{\"childValue\":\"固态\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10010, '1006', '[{\"value\":\"主题\",\"children\":[{\"childValue\":\"好看\",\"value\":\"\"}]},{\"value\":\"时么\",\"children\":[{\"value\":\"\",\"children\":[],\"childValue\":\"时的1\"},{\"childValue\":\"是的2\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10011, '1007', '[{\"value\":\"空调\",\"children\":[{\"childValue\":\"123\",\"value\":\"\"},{\"childValue\":\"123\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10012, '1008', '[{\"value\":\"电脑\",\"children\":[{\"childValue\":\"网线\",\"value\":\"\"},{\"childValue\":\"接口\",\"value\":\"\"}]},{\"value\":\"鼠标\",\"children\":[{\"childValue\":\"有限\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10013, '1009', '[{\"value\":\"品牌\",\"children\":[{\"childValue\":\"戴尔\",\"value\":\"\"},{\"childValue\":\"宏碁\",\"value\":\"\"},{\"childValue\":\"mac\",\"value\":\"\"},{\"childValue\":\"小米\",\"value\":\"\"}]},{\"value\":\"内存\",\"children\":[{\"value\":\"\",\"childValue\":\"256\"},{\"childValue\":\"固态\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10014, '1010', '[{\"value\":\"主题\",\"children\":[{\"childValue\":\"好看\",\"value\":\"\"}]},{\"value\":\"时么\",\"children\":[{\"value\":\"\",\"children\":[],\"childValue\":\"时的1\"},{\"childValue\":\"是的2\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10015, '1011', '[{\"value\":\"空调\",\"children\":[{\"childValue\":\"123\",\"value\":\"\"},{\"childValue\":\"123\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10016, '1012', '[{\"value\":\"电脑\",\"children\":[{\"childValue\":\"网线\",\"value\":\"\"},{\"childValue\":\"接口\",\"value\":\"\"}]},{\"value\":\"鼠标\",\"children\":[{\"childValue\":\"有限\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10017, '1013', '[{\"value\":\"品牌\",\"children\":[{\"childValue\":\"戴尔\",\"value\":\"\"},{\"childValue\":\"宏碁\",\"value\":\"\"},{\"childValue\":\"mac\",\"value\":\"\"},{\"childValue\":\"小米\",\"value\":\"\"}]},{\"value\":\"内存\",\"children\":[{\"value\":\"\",\"childValue\":\"256\"},{\"childValue\":\"固态\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10018, '1014', '[{\"value\":\"主题\",\"children\":[{\"childValue\":\"好看\",\"value\":\"\"}]},{\"value\":\"时么\",\"children\":[{\"value\":\"\",\"children\":[],\"childValue\":\"时的1\"},{\"childValue\":\"是的2\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10019, '1015', '[{\"value\":\"空调\",\"children\":[{\"childValue\":\"123\",\"value\":\"\"},{\"childValue\":\"123\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10020, '1016', '[{\"value\":\"电脑\",\"children\":[{\"childValue\":\"网线\",\"value\":\"\"},{\"childValue\":\"接口\",\"value\":\"\"}]},{\"value\":\"鼠标\",\"children\":[{\"childValue\":\"有限\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10021, '1017', '[{\"value\":\"品牌\",\"children\":[{\"childValue\":\"戴尔\",\"value\":\"\"},{\"childValue\":\"宏碁\",\"value\":\"\"},{\"childValue\":\"mac\",\"value\":\"\"},{\"childValue\":\"小米\",\"value\":\"\"}]},{\"value\":\"内存\",\"children\":[{\"value\":\"\",\"childValue\":\"256\"},{\"childValue\":\"固态\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10022, '1018', '[{\"value\":\"主题\",\"children\":[{\"childValue\":\"好看\",\"value\":\"\"}]},{\"value\":\"时么\",\"children\":[{\"value\":\"\",\"children\":[],\"childValue\":\"时的1\"},{\"childValue\":\"是的2\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10023, '1019', '[{\"value\":\"空调\",\"children\":[{\"childValue\":\"123\",\"value\":\"\"},{\"childValue\":\"123\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10024, '1020', '[{\"value\":\"电脑\",\"children\":[{\"childValue\":\"网线\",\"value\":\"\"},{\"childValue\":\"接口\",\"value\":\"\"}]},{\"value\":\"鼠标\",\"children\":[{\"childValue\":\"有限\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10025, '1021', '[{\"value\":\"品牌\",\"children\":[{\"childValue\":\"戴尔\",\"value\":\"\"},{\"childValue\":\"宏碁\",\"value\":\"\"},{\"childValue\":\"mac\",\"value\":\"\"},{\"childValue\":\"小米\",\"value\":\"\"}]},{\"value\":\"内存\",\"children\":[{\"value\":\"\",\"childValue\":\"256\"},{\"childValue\":\"固态\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10026, '1022', '[{\"value\":\"主题\",\"children\":[{\"childValue\":\"好看\",\"value\":\"\"}]},{\"value\":\"时么\",\"children\":[{\"value\":\"\",\"children\":[],\"childValue\":\"时的1\"},{\"childValue\":\"是的2\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10027, '1023', '[{\"value\":\"空调\",\"children\":[{\"childValue\":\"123\",\"value\":\"\"},{\"childValue\":\"123\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10028, '1024', '[{\"value\":\"电脑\",\"children\":[{\"childValue\":\"网线\",\"value\":\"\"},{\"childValue\":\"接口\",\"value\":\"\"}]},{\"value\":\"鼠标\",\"children\":[{\"childValue\":\"有限\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10031, '1027', '[{\"value\":\"空调\",\"children\":[{\"childValue\":\"123\",\"value\":\"\"},{\"childValue\":\"123\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10032, '1028', '[{\"value\":\"电脑\",\"children\":[{\"childValue\":\"网线\",\"value\":\"\"},{\"childValue\":\"接口\",\"value\":\"\"}]},{\"value\":\"鼠标\",\"children\":[{\"childValue\":\"有限\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10033, '1001', '[{\"title\":\"主体\",\"value\":\"\",\"children\":[{\"title\":\"上市时间\",\"value\":\"\"}]},{\"title\":\"功能\",\"value\":\"\",\"children\":[{\"title\":\"制冷\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10034, '10001', '[{\"title\":\"上架时间\",\"value\":\"\",\"children\":[{\"title\":\"2023.1.1\",\"value\":\"\"}]},{\"title\":\"大小\",\"value\":\"\",\"children\":[{\"title\":\"50寸\",\"value\":\"\"},{\"title\":\"1mm\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10035, '1002', '[{\"title\":\"安卓\",\"value\":\"\",\"children\":[{\"title\":\"华为\",\"value\":\"\"},{\"title\":\"小米\",\"value\":\"\"}]},{\"title\":\"苹果\",\"value\":\"\",\"children\":[{\"title\":\"iphone13\",\"value\":\"\"},{\"title\":\"iphone12\",\"value\":\"\"},{\"title\":\"iphone11\",\"value\":\"\"}]}]');
INSERT INTO `params` (`id`, `itemCatId`, `paramData`) VALUES (10036, '1003', '[{\"title\":\"windows\",\"value\":\"\",\"children\":[{\"title\":\"联想\",\"value\":\"\"},{\"title\":\"华为\",\"value\":\"\"},{\"title\":\"拯救者\",\"value\":\"\"}]},{\"title\":\"macos\",\"value\":\"\",\"children\":[{\"title\":\"macbook\",\"value\":\"\"},{\"title\":\"macbook pro\",\"value\":\"\"}]}]');
COMMIT;

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `image` text NOT NULL,
  `sellPoint` text NOT NULL,
  `price` text NOT NULL,
  `cid` text NOT NULL,
  `num` text NOT NULL,
  `barcode` text NOT NULL,
  `status` text NOT NULL,
  `created` text NOT NULL,
  `updated` text NOT NULL,
  `descs` text NOT NULL,
  `category` text NOT NULL,
  `paramsInfo` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10080 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of project
-- ----------------------------
BEGIN;
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (1, '三国演义', 'upload\\11596077819396-img.jpg', '中国名著', '113.91', '10001', '6775', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (2, '水浒传', 'upload\\11596077819396-img.jpg', '中国名著', '398.72', '10002', '3795', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (3, '西游记', 'upload\\11596077819396-img.jpg', '中国名著', '420.15', '10003', '5927', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (4, '红楼梦', 'upload\\11596077819396-img.jpg', '中国名著', '910.09', '10004', '3636', '', '', '', '', '值得看一看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (5, '伊利亚特', 'upload\\11596077819396-img.jpg', '外国名著', '227.8', '10005', '1248', '', '', '', '', '值得看一看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (6, '历史', 'upload\\11596077819396-img.jpg', '外国名著', '515.66', '10006', '6134', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (7, '伯罗奔尼撒战争史', 'upload\\11596077819396-img.jpg', '外国名著', '566.64', '10007', '221', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (8, '茶花女', 'upload\\11596077819396-img.jpg', '外国名著', '127.33', '10008', '6918', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (9, '对话录', 'upload\\11596077819396-img.jpg', '外国名著', '769.02', '10009', '3377', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (10, '埃涅阿斯记', 'upload\\11596077819396-img.jpg', '外国名著', '333.72', '10010', '7042', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (11, '希腊罗马英雄史', 'upload\\11596077819396-img.jpg', '外国名著', '61.82', '10011', '3550', '', '', '', '', '未曾开言，我先笑场，笑过之后，听我来诉一诉衷肠', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (12, '80位伟人的故事', 'upload\\11596077819396-img.jpg', '外国名著', '119.29', '10012', '6626', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (13, '四世同堂', 'upload\\11596077819396-img.jpg', '外国名著', '632.6', '10013', '6012', '', '', '', '', '值得看一看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (14, '神曲', 'upload\\11596077819396-img.jpg', '外国名著', '648.59', '10014', '4184', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (15, '坎特伯雷故事集', 'upload\\11596077819396-img.jpg', '外国名著', '215.55', '10015', '5977', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (16, '乌托邦', 'upload\\11596077819396-img.jpg', '外国名著', '813', '10016', '4867', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (17, '君王论', 'upload\\11596077819396-img.jpg', '外国名著', '52.56', '10017', '681', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (18, '巨人传', 'upload\\11596077819396-img.jpg', '外国名著', '668.97', '10018', '95', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (19, '堂吉柯德', 'upload\\11596077819396-img.jpg', '外国名著', '88', '10019', '252', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (20, '箴言集', 'upload\\11596077819396-img.jpg', '外国名著', '430.47', '10020', '2961', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (21, '失乐园', 'upload\\11596077819396-img.jpg', '外国名著', '261.64', '10021', '7622', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (22, '天路历程', 'upload\\11596077819396-img.jpg', '外国名著', '367.65', '10022', '6283', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (23, '一千零一夜', 'upload\\11596077819396-img.jpg', '外国名著', '91.3', '10023', '3085', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (24, '鲁滨逊漂流记', 'upload\\11596077819396-img.jpg', '外国名著', '156.06', '10024', '2276', '', '', '', '', '值得看一看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (25, '格列佛游记', 'upload\\11596077819396-img.jpg', '外国名著', '102.47', '10025', '1964', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (26, '汤姆琼斯', 'upload\\11596077819396-img.jpg', '外国名著', '237.65', '10026', '4074', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (27, '社会契约论', 'upload\\11596077819396-img.jpg', '外国名著', '114.5', '10027', '3623', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (28, '国富论', 'upload\\11596077819396-img.jpg', '外国名著', '45.96', '10028', '4705', '', '', '', '', '值得看一看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (29, '罗马帝国衰亡史', 'upload\\11596077819396-img.jpg', '外国名著', '770.84', '10029', '2342', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (30, '纯粹理性批判', 'upload\\11596077819396-img.jpg', '外国名著', '660.69', '10030', '6527', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (31, '约翰生转', 'upload\\11596077819396-img.jpg', '外国名著', '219.82', '10031', '6384', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (32, '女权辩论', 'upload\\11596077819396-img.jpg', '外国名著', '329.51', '10032', '1560', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (33, '情爱论', 'upload\\11596077819396-img.jpg', '外国名著', '627.05', '10033', '3406', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (34, '人口论', 'upload\\11596077819396-img.jpg', '外国名著', '209.46', '10034', '2362', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (35, '傲慢与偏见', 'upload\\11596077819396-img.jpg', '外国名著', '385.96', '10035', '2301', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (36, '艾凡赫', 'upload\\11596077819396-img.jpg', '外国名著', '157.33', '10036', '3642', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (37, '红与黑', 'upload\\11596077819396-img.jpg', '外国名著', '499.78', '10037', '787', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (38, '巴黎圣母院', 'upload\\11596077819396-img.jpg', '外国名著', '431.22', '10038', '1358', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (39, '高老头', 'upload\\11596077819396-img.jpg', '外国名著', '453.14', '10039', '6554', '', '', '', '', '未曾开言，我先笑场，笑过之后，听我来诉一诉衷肠', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (40, '三剑客', 'upload\\11596077819396-img.jpg', '外国名著', '469.02', '10040', '173', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (41, '简爱', 'upload\\11596077819396-img.jpg', '外国名著', '57.65', '10041', '725', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (42, '呼啸山庄', 'upload\\11596077819396-img.jpg', '外国名著', '341.66', '10042', '5528', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (43, '英国史', 'upload\\11596077819396-img.jpg', '外国名著', '608.27', '10043', '1040', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (44, '包法利夫人', 'upload\\11596077819396-img.jpg', '外国名著', '283.27', '10044', '820', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (45, '论自由', 'upload\\11596077819396-img.jpg', '外国名著', '271.93', '10045', '752', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (46, '物种起源', 'upload\\11596077819396-img.jpg', '外国名著', '174.4', '10046', '3436', '', '', '', '', '未曾开言，我先笑场，笑过之后，听我来诉一诉衷肠', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (47, '弗洛斯河上的磨砺', 'upload\\11596077819396-img.jpg', '外国名著', '350.4', '10047', '344', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (48, '父与子', 'upload\\11596077819396-img.jpg', '外国名著', '271.26', '10048', '559', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (49, '战争与和平', 'upload\\11596077819396-img.jpg', '外国名著', '342.37', '10049', '3981', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (50, '爱丽丝漫游奇境记', 'upload\\11596077819396-img.jpg', '外国名著', '185.05', '10050', '8703', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (51, '安娜卡列尼娜', 'upload\\11596077819396-img.jpg', '外国名著', '333.32', '10051', '5378', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (52, '八十天环游世界', 'upload\\11596077819396-img.jpg', '外国名著', '643.32', '10052', '1105', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (53, '汤姆索亚历险记', 'upload\\11596077819396-img.jpg', '外国名著', '119.65', '10053', '9059', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (54, '卡拉马佐夫兄弟', 'upload\\11596077819396-img.jpg', '外国名著', '652.15', '10054', '4915', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (55, '金枝', 'upload\\11596077819396-img.jpg', '外国名著', '363.52', '10055', '181', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (56, '苔丝', 'upload\\11596077819396-img.jpg', '外国名著', '828.65', '10056', '5290', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (57, '梦的解析', 'upload\\11596077819396-img.jpg', '外国名著', '681.17', '10057', '8', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (58, '包扎先生的历史', 'upload\\11596077819396-img.jpg', '外国名著', '487.3', '10058', '4267', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (59, '追忆逝水年华', 'upload\\11596077819396-img.jpg', '外国名著', '421.04', '10059', '349', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (60, '尤利西斯', 'upload\\11596077819396-img.jpg', '外国名著', '98.52', '10060', '1140', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (61, '魔山', 'upload\\11596077819396-img.jpg', '外国名著', '391.31', '10061', '2424', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (62, '美丽的悲剧', 'upload\\11596077819396-img.jpg', '外国名著', '68.66', '10062', '410', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (63, '如果麦子不死', 'upload\\11596077819396-img.jpg', '外国名著', '913.9', '10063', '4082', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (64, '灯塔', 'upload\\11596077819396-img.jpg', '外国名著', '135.29', '10064', '2081', '', '', '', '', '非常好看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (65, '喧嚣与骚动', 'upload\\11596077819396-img.jpg', '外国名著', '902.6', '10065', '1317', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (66, '西线无故事', 'upload\\11596077819396-img.jpg', '外国名著', '111.82', '10066', '96', '', '', '', '', '值得看一看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (67, '愤怒的葡萄', 'upload\\11596077819396-img.jpg', '外国名著', '578.47', '10067', '2966', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (68, '智慧七柱', 'upload\\11596077819396-img.jpg', '外国名著', '277.62', '10068', '3972', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (69, '一九八四', 'upload\\11596077819396-img.jpg', '外国名著', '49.41', '10069', '1257', '', '', '', '', '未曾开言，我先笑场，笑过之后，听我来诉一诉衷肠', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (70, '岗铁基探险记', 'upload\\11596077819396-img.jpg', '外国名著', '827.56', '10070', '1881', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (71, '大师群像', 'upload\\11596077819396-img.jpg', '外国名著', '326.99', '10071', '1458', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (72, '亚历山大四重奏', 'upload\\11596077819396-img.jpg', '外国名著', '585.05', '10072', '1005', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (73, '日瓦戈医生', 'upload\\11596077819396-img.jpg', '外国名著', '326.26', '10073', '1814', '', '', '', '', '值得看一看', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (74, '诗经', 'upload\\11596077819396-img.jpg', '中国名著', '213.76', '10074', '2651', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (75, '论语', 'upload\\11596077819396-img.jpg', '中国名著', '170.43', '10075', '4905', '', '', '', '', '未曾开言，我先笑场，笑过之后，听我来诉一诉衷肠', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (76, '庄子', 'upload\\11596077819396-img.jpg', '中国名著', '299.05', '10076', '73', '', '', '', '', '还不错，但是要看书籍，不要看电影', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (77, '孟子', 'upload\\11596077819396-img.jpg', '中国名著', '657.42', '10077', '1375', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (78, '史记', 'http://127.0.0.1:7878/1674157411449-æªå±2023-01-18 19.51.51.png', '中国名著', '404.8', '10078', '358', '', '', '', '', '人不是慢慢变老的，而是一瞬间变老的', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (79, '楚辞', 'http://127.0.0.1:7878/1674157376154-4d4a6880b6b36807d6c328888ef8854c.jpg', '中国名著', '731.45', '10079', '1160', '', '', '', '', '所有人都曾是小孩，虽然之后少数人记得', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (80, '牡丹亭', 'http://127.0.0.1:7878/1674157422781-æªå±2023-01-18 19.57.45.png', '中国名著', '151.54', '10080', '1518', '', '', '', '', '人生尔尔，错过了，就是一辈子', '', '');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (10075, 'as', 'http://127.0.0.1:7878/1674155948928-æªå±2023-01-18 20.36.56.png', 'as', 'as', '', 'as', '', '', '1', '', 'as', '电脑/办公', '[{\"value\":\"空调aaaaa\",\"children\":[{\"childValue\":\"123aaaaaa\",\"value\":\"\"},{\"childValue\":\"123aaaaa\",\"value\":\"\"}]}]');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (10076, 'macbook', 'http://127.0.0.1:7878/1674156100258-æªå±2023-01-18 19.55.17.png', '流畅', '9999', '', '12', '', '', '1', '', '非常好用', '电脑/办公', '[{\"value\":\"mac\",\"children\":[{\"childValue\":\"macos\",\"value\":\"\"},{\"childValue\":\"\",\"value\":\"\"}]}]');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (10078, 'as', 'http://127.0.0.1:7878/1674157359835-æªå±2023-01-18 20.36.48.png', 'aaaaaaaa', 'as', '', 'aaaaaaaaaa', '', '', '1', '', 'aaaaaaaaa', '家用电器', '[{\"value\":\"品牌aaa\",\"children\":[{\"childValue\":\"戴尔aaaaa\",\"value\":\"\"},{\"childValue\":\"宏碁aaaa\",\"value\":\"\"},{\"childValue\":\"macaaaa\",\"value\":\"\"},{\"childValue\":\"小米\",\"value\":\"\"}]},{\"value\":\"内存\",\"children\":[{\"value\":\"\",\"childValue\":\"256\"},{\"childValue\":\"固态\",\"value\":\"\"}]}]');
INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `category`, `paramsInfo`) VALUES (10079, 'a', 'http://127.0.0.1:7878/1674157376154-4d4a6880b6b36807d6c328888ef8854c.jpg', 'a', 'a', '', 'a', '', '', '1', '', 'a', '家用电器', '[{\"value\":\"品牌aaa\",\"children\":[{\"childValue\":\"戴尔aaa\",\"value\":\"\"},{\"childValue\":\"宏碁aaa\",\"value\":\"\"},{\"childValue\":\"mac\",\"value\":\"\"},{\"childValue\":\"小米\",\"value\":\"\"}]},{\"value\":\"内存\",\"children\":[{\"value\":\"\",\"childValue\":\"256\"},{\"childValue\":\"固态\",\"value\":\"\"}]}]');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `email` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `email`) VALUES (1, 'admin', '123', '123456789@qq.com');
INSERT INTO `user` (`id`, `username`, `password`, `email`) VALUES (2, 'xiaotian', '123', '123456789@qq.com');
INSERT INTO `user` (`id`, `username`, `password`, `email`) VALUES (12, 'wifi', '123', '123@qq.com');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
